<?php
/**
 * @version		$Id: item.php 1727 2012-10-09 10:29:30Z lefteris.kavadas $
 * @package		K2
 * @author		JoomlaWorks http://www.joomlaworks.net
 * @copyright	Copyright (c) 2006 - 2012 JoomlaWorks Ltd. All rights reserved.
 * @license		GNU/GPL license: http://www.gnu.org/copyleft/gpl.html
 */

// no direct access
defined('_JEXEC') or die ;

jimport('joomla.application.component.model');

JTable::addIncludePath(JPATH_COMPONENT_ADMINISTRATOR.DS.'tables');

class K2ModelItem extends K2Model
{

    function getData()
    {
        $mainframe = JFactory::getApplication();
        $id = JRequest::getInt('id');
        $db = JFactory::getDBO();
        $query = "SELECT * FROM #__k2_items WHERE id={$id}";
        if (K2_JVERSION != '15')
        {
            $languageFilter = $mainframe->getLanguageFilter();
            if ($languageFilter)
            {
                $languageTag = JFactory::getLanguage()->getTag();
                $query .= " AND language IN (".$db->Quote($languageTag).",".$db->Quote('*').")";
            }
        }
        $db->setQuery($query, 0, 1);
        $row = $db->loadObject();
        return $row;
    }

    function prepareItem($item, $view, $task)
    {

        jimport('joomla.filesystem.file');
        JTable::addIncludePath(JPATH_COMPONENT_ADMINISTRATOR.DS.'tables');
        $limitstart = JRequest::getInt('limitstart');
        $application = JFactory::getApplication();
        //Initialize params
        if ($view != 'item')
        {

            $component = JComponentHelper::getComponent('com_k2');
            $params = class_exists('JParameter') ? new JParameter($component->params) : new JRegistry($component->params);
            $itemid = JRequest::getInt('Itemid');
            if ($itemid)
            {
                $menu = $application->getMenu();
                $menuparams = $menu->getParams($itemid);
                $params->merge($menuparams);
            }

        }
        else
        {
            $params = K2HelperUtilities::getParams('com_k2');
        }

        //Category
        $db = JFactory::getDBO();
        $category = JTable::getInstance('K2Category', 'Table');
        $category->load($item->catid);

        $item->category = $category;
        $item->category->link = urldecode(JRoute::_(K2HelperRoute::getCategoryRoute($category->id.':'.urlencode($category->alias))));

        //Read more link
        $link = K2HelperRoute::getItemRoute($item->id.':'.urlencode($item->alias), $item->catid.':'.urlencode($item->category->alias));
        $item->link = urldecode(JRoute::_($link));

        //Print link
        $item->printLink = urldecode(JRoute::_($link.'&tmpl=component&print=1'));

        //Params
        $cparams = class_exists('JParameter') ? new JParameter($category->params) : new JRegistry($category->params);
        $iparams = class_exists('JParameter') ? new JParameter($item->params) : new JRegistry($item->params);
        $item->params = $params;
        if ($cparams->get('inheritFrom'))
        {
            $masterCategoryID = $cparams->get('inheritFrom');
            $masterCategory = JTable::getInstance('K2Category', 'Table');
            $masterCategory->load((int)$masterCategoryID);
            $cparams = class_exists('JParameter') ? new JParameter($masterCategory->params) : new JRegistry($masterCategory->params);
        }
        $item->params->merge($cparams);
        $item->params->merge($iparams);

        //Edit link
        if (K2HelperPermissions::canEditItem($item->created_by, $item->catid))
            $item->editLink = JRoute::_('index.php?option=com_k2&view=item&task=edit&cid='.$item->id.'&tmpl=component');

        //Tags
        if (($view == 'item' && ($item->params->get('itemTags') || $item->params->get('itemRelated'))) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemTags')) || ($view == 'itemlist' && $task == 'user' && $item->params->get('userItemTags')) || ($view == 'latest' && $params->get('latestItemTags')))
        {
            $tags = $this->getItemTags($item->id);
            for ($i = 0; $i < sizeof($tags); $i++)
            {
                $tags[$i]->link = JRoute::_(K2HelperRoute::getTagRoute($tags[$i]->name));
            }
            $item->tags = $tags;
        }

        //Image
        $item->imageXSmall = '';
        $item->imageSmall = '';
        $item->imageMedium = '';
        $item->imageLarge = '';
        $item->imageXLarge = '';

        $date = JFactory::getDate($item->modified);
        $timestamp = '?t='.$date->toUnix();

        if (JFile::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.md5("Image".$item->id).'_XS.jpg'))
        {
            $item->imageXSmall = JURI::base(true).'/media/k2/items/cache/'.md5("Image".$item->id).'_XS.jpg';
            if ($params->get('imageTimestamp'))
            {
                $item->imageXSmall .= $timestamp;
            }
        }

        if (JFile::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.md5("Image".$item->id).'_S.jpg'))
        {
            $item->imageSmall = JURI::base(true).'/media/k2/items/cache/'.md5("Image".$item->id).'_S.jpg';
            if ($params->get('imageTimestamp'))
            {
                $item->imageSmall .= $timestamp;
            }
        }

        if (JFile::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.md5("Image".$item->id).'_M.jpg'))
        {
            $item->imageMedium = JURI::base(true).'/media/k2/items/cache/'.md5("Image".$item->id).'_M.jpg';
            if ($params->get('imageTimestamp'))
            {
                $item->imageMedium .= $timestamp;
            }
        }

        if (JFile::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.md5("Image".$item->id).'_L.jpg'))
        {
            $item->imageLarge = JURI::base(true).'/media/k2/items/cache/'.md5("Image".$item->id).'_L.jpg';
            if ($params->get('imageTimestamp'))
            {
                $item->imageLarge .= $timestamp;
            }
        }

        if (JFile::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.md5("Image".$item->id).'_XL.jpg'))
        {
            $item->imageXLarge = JURI::base(true).'/media/k2/items/cache/'.md5("Image".$item->id).'_XL.jpg';
            if ($params->get('imageTimestamp'))
            {
                $item->imageXLarge .= $timestamp;
            }
        }

        if (JFile::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.md5("Image".$item->id).'_Generic.jpg'))
        {
            $item->imageGeneric = JURI::base(true).'/media/k2/items/cache/'.md5("Image".$item->id).'_Generic.jpg';
            if ($params->get('imageTimestamp'))
            {
                $item->imageGeneric .= $timestamp;
            }
        }

        //Extra fields
        if (($view == 'item' && $item->params->get('itemExtraFields')) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemExtraFields')) || ($view == 'itemlist' && $task == 'tag' && $item->params->get('tagItemExtraFields')) || ($view == 'itemlist' && ($task == 'search' || $task == 'date') && $item->params->get('genericItemExtraFields')))
        {
            $item->extra_fields = $this->getItemExtraFields($item->extra_fields);
        }

        //Attachments
        if (($view == 'item' && $item->params->get('itemAttachments')) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemAttachments')))
        {
            $item->attachments = $this->getItemAttachments($item->id);
        }

        //Rating
        if (($view == 'item' && $item->params->get('itemRating')) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemRating')))
        {
            $item->votingPercentage = $this->getVotesPercentage($item->id);
            $item->numOfvotes = $this->getVotesNum($item->id);

        }

        //Filtering
        if ($params->get('introTextCleanup'))
        {
            $filterTags = preg_split('#[,\s]+#', trim($params->get('introTextCleanupExcludeTags')));
            $filterAttrs = preg_split('#[,\s]+#', trim($params->get('introTextCleanupTagAttr')));
            $filter = new JFilterInput($filterTags, $filterAttrs, 0, 1);
            $item->introtext = $filter->clean($item->introtext);
        }

        if ($params->get('fullTextCleanup'))
        {
            $filterTags = preg_split('#[,\s]+#', trim($params->get('fullTextCleanupExcludeTags')));
            $filterAttrs = preg_split('#[,\s]+#', trim($params->get('fullTextCleanupTagAttr')));
            $filter = new JFilterInput($filterTags, $filterAttrs, 0, 1);
            $item->fulltext = $filter->clean($item->fulltext);
        }

        if ($item->params->get('catItemIntroTextWordLimit') && $task == 'category')
        {
            $item->introtext = K2HelperUtilities::wordLimit($item->introtext, $item->params->get('catItemIntroTextWordLimit'));
        }

        $item->cleanTitle = $item->title;
        $item->title = htmlspecialchars($item->title, ENT_QUOTES);
        $item->image_caption = htmlspecialchars($item->image_caption, ENT_QUOTES);

        //Author
        if (($view == 'item' && ($item->params->get('itemAuthorBlock') || $item->params->get('itemAuthor'))) || ($view == 'itemlist' && ($task == '' || $task == 'category') && ($item->params->get('catItemAuthorBlock') || $item->params->get('catItemAuthor'))) || ($view == 'itemlist' && $task == 'user') || ($view == 'relatedByTag'))
        {
            if (!empty($item->created_by_alias))
            {
                $item->author = new stdClass;
                $item->author->name = $item->created_by_alias;
                $item->author->avatar = K2HelperUtilities::getAvatar('alias');
                $item->author->link = JURI::root();
            }
            else
            {
                $author = JFactory::getUser($item->created_by);
                $item->author = $author;
                $item->author->link = JRoute::_(K2HelperRoute::getUserRoute($item->created_by));
                $item->author->profile = $this->getUserProfile($item->created_by);
                $item->author->avatar = K2HelperUtilities::getAvatar($author->id, $author->email, $params->get('userImageWidth'));
            }

            if (!isset($item->author->profile) || is_null($item->author->profile))
            {

                $item->author->profile = new JObject;
                $item->author->profile->gender = NULL;

            }

        }

        //Num of comments
        $user = JFactory::getUser();
        if (!$user->guest && $user->id == $item->created_by && $params->get('inlineCommentsModeration'))
        {
            $item->numOfComments = $this->countItemComments($item->id, false);
        }
        else
        {
            $item->numOfComments = $this->countItemComments($item->id);
        }
        return $item;
    }

    function prepareFeedItem(&$item)
    {

        JTable::addIncludePath(JPATH_COMPONENT_ADMINISTRATOR.DS.'tables');
        $params = K2HelperUtilities::getParams('com_k2');
        $limitstart = 0;
        $view = JRequest::getCmd('view');
        //Category
        $category = JTable::getInstance('K2Category', 'Table');
        $category->load($item->catid);
        $item->category = $category;

        //Read more link
        $item->link = urldecode(JRoute::_(K2HelperRoute::getItemRoute($item->id.':'.$item->alias, $item->catid.':'.urlencode($item->category->alias))));

        //Filtering
        if ($params->get('introTextCleanup'))
        {
            $filterTags = preg_split('#[,\s]+#', trim($params->get('introTextCleanupExcludeTags')));
            $filterAttrs = preg_split('#[,\s]+#', trim($params->get('introTextCleanupTagAttr')));
            $filter = new JFilterInput($filterTags, $filterAttrs, 0, 1);
            $item->introtext = $filter->clean($item->introtext);
        }

        if ($params->get('fullTextCleanup'))
        {
            $filterTags = preg_split('#[,\s]+#', trim($params->get('fullTextCleanupExcludeTags')));
            $filterAttrs = preg_split('#[,\s]+#', trim($params->get('fullTextCleanupTagAttr')));
            $filter = new JFilterInput($filterTags, $filterAttrs, 0, 1);
            $item->fulltext = $filter->clean($item->fulltext);
        }

        //Description
        $item->description = '';

        //Item image
        if ($params->get('feedItemImage') && JFile::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.md5("Image".$item->id).'_'.$params->get('feedImgSize').'.jpg'))
        {
            $item->description .= '<div class="K2FeedImage"><img src="'.JURI::root().'media/k2/items/cache/'.md5('Image'.$item->id).'_'.$params->get('feedImgSize').'.jpg" alt="'.$item->title.'" /></div>';
        }

        //Item Introtext
        if ($params->get('feedItemIntroText'))
        {
            //Introtext word limit
            if ($params->get('feedTextWordLimit') && $item->introtext)
            {
                $item->introtext = K2HelperUtilities::wordLimit($item->introtext, $params->get('feedTextWordLimit'));
            }
            $item->description .= '<div class="K2FeedIntroText">'.$item->introtext.'</div>';
        }

        //Item Fulltext
        if ($params->get('feedItemFullText') && $item->fulltext)
        {
            $item->description .= '<div class="K2FeedFullText">'.$item->fulltext.'</div>';
        }

        //Item Tags
        if ($params->get('feedItemTags'))
        {
            $tags = $this->getItemTags($item->id);
            if (count($tags))
            {
                $item->description .= '<div class="K2FeedTags"><ul>';
                foreach ($tags as $tag)
                {
                    $item->description .= '<li>'.$tag->name.'</li>';
                }
                $item->description .= '<ul></div>';
            }
        }

        //Item Video
        if ($params->get('feedItemVideo') && $item->video)
        {
            if (!empty($item->video) && JString::substr($item->video, 0, 1) !== '{')
            {
                $item->description .= '<div class="K2FeedVideo">'.$item->video.'</div>';
            }
            else
            {
                $params->set('vfolder', 'media/k2/videos');
                $params->set('afolder', 'media/k2/audio');
                if (JString::strpos($item->video, 'remote}'))
                {
                    preg_match("#}(.*?){/#s", $item->video, $matches);
                    if (!JString::strpos($matches[1], 'http://}'))
                        $item->video = str_replace($matches[1], JURI::root().$matches[1], $item->video);
                }
                $dispatcher = JDispatcher::getInstance();
                JPluginHelper::importPlugin('content');
                $item->text = $item->video;
                if (K2_JVERSION == '15')
                {
                    $dispatcher->trigger('onPrepareContent', array(&$item, &$params, $limitstart));
                }
                else
                {
                    $dispatcher->trigger('onContentPrepare', array('com_k2.'.$view, &$item, &$params, $limitstart));
                }                $item->description .= '<div class="K2FeedVideo">'.$item->text.'</div>';
            }
        }

        //Item gallery
        if ($params->get('feedItemGallery') && $item->gallery)
        {
            $params->set('galleries_rootfolder', 'media/k2/galleries');
            $params->set('enabledownload', '0');
            $dispatcher = JDispatcher::getInstance();
            JPluginHelper::importPlugin('content');
            $item->text = $item->gallery;
            if (K2_JVERSION == '15')
            {
                $dispatcher->trigger('onPrepareContent', array(&$item, &$params, $limitstart));
            }
            else
            {
                $dispatcher->trigger('onContentPrepare', array('com_k2.'.$view, &$item, &$params, $limitstart));
            }
            $item->description .= '<div class="K2FeedGallery">'.$item->text.'</div>';
        }

        //Item attachments
        if ($params->get('feedItemAttachments'))
        {
            $attachments = $this->getItemAttachments($item->id);
            if (count($attachments))
            {
                $item->description .= '<div class="K2FeedAttachments"><ul>';
                foreach ($attachments as $attachment)
                {
                    $item->description .= '<li><a title="'.htmlentities($attachment->titleAttribute, ENT_QUOTES, 'UTF-8').'" href="'.$attachment->link.'">'.$attachment->title.'</a></li>';
                }
                $item->description .= '<ul></div>';
            }
        }

        //Author
        if (!empty($item->created_by_alias))
        {
            $item->author->name = $item->created_by_alias;
            $item->author->email = '';
        }
        else
        {
            $author = JFactory::getUser($item->created_by);
            $item->author = $author;
            $item->author->link = JRoute::_(K2HelperRoute::getUserRoute($item->created_by));
            $item->author->profile = $this->getUserProfile($item->created_by);
        }

        return $item;
    }

    function prepareJSONItem($item)
    {
        $row = new JObject();
        unset($row->_errors);
        $row->id = $item->id;
        $row->title = $item->title;
        $row->alias = $item->alias;
        $row->link = $item->link;
        $row->catid = $item->catid;
        $row->introtext = $item->introtext;
        $row->fulltext = $item->fulltext;
        $row->extra_fields = $item->extra_fields;
        $row->created = $item->created;
        //$row->created_by = $item->created_by;
        $row->created_by_alias = $item->created_by_alias;
        $row->modified = $item->modified;
        //$row->modified_by = $item->modified_by;
        $row->featured = $item->featured;
        //$row->ordering = $item->ordering;
        //$row->featured_ordering = $item->featured_ordering;
        $row->image = isset($item->image) ? $item->image : '';
        $row->imageWidth = isset($item->imageWidth) ? $item->imageWidth : '';
        $row->image_caption = $item->image_caption;
        $row->image_credits = $item->image_credits;
        $row->imageXSmall = $item->imageXSmall;
        $row->imageSmall = $item->imageSmall;
        $row->imageMedium = $item->imageMedium;
        $row->imageLarge = $item->imageLarge;
        $row->imageXLarge = $item->imageXLarge;
        $row->video = $item->video;
        $row->video_caption = $item->video_caption;
        $row->video_credits = $item->video_credits;
        $row->gallery = $item->gallery;
        $row->hits = $item->hits;
        //$row->plugins = $item->plugins;
        $row->category = new stdClass;
        $row->category->id = $item->category->id;
        $row->category->name = $item->category->name;
        $row->category->alias = $item->category->alias;
        $row->category->link = $item->category->link;
        $row->category->description = $item->category->description;
        $row->category->image = $item->category->image;
        $row->category->ordering = $item->category->ordering;
        //$row->category->plugins = $item->category->plugins;
        $row->tags = isset($item->tags) ? $item->tags : array();
        $row->attachments = isset($item->attachments) ? $item->attachments : array();
        $row->votingPercentage = isset($item->votingPercentage) ? $item->votingPercentage : '';
        $row->numOfvotes = isset($item->numOfvotes) ? $item->numOfvotes : '';
        if (isset($item->author))
        {
            $row->author = new stdClass;
            //$row->author->id = $item->author->id;
            $row->author->name = $item->author->name;
            //$row->author->username = $item->author->username;
            $row->author->link = $item->author->link;
            $row->author->avatar = $item->author->avatar;
            if (isset($item->author->profile))
            {
                unset($item->author->profile->plugins);
            }
            $row->author->profile = $item->author->profile;
        }
        $row->numOfComments = $item->numOfComments;
        $row->events = $item->event;
        $row->language = $item->language;
        return $row;
    }

    function execPlugins($item, $view, $task)
    {

        $params = K2HelperUtilities::getParams('com_k2');
        $limitstart = JRequest::getInt('limitstart');
        $view = JRequest::getCmd('view');
        //Import plugins
        $dispatcher = JDispatcher::getInstance();
        JPluginHelper::importPlugin('content');

        //Gallery
        if (($view == 'item' && $item->params->get('itemImageGallery')) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemImageGallery')) || ($view == 'relatedByTag'))
        {
            if ($item->gallery)
            {
                if (JString::strpos($item->gallery, 'flickr.com') === false)
                {
                    $item->gallery = "{gallery}{$item->id}{/gallery}";
                    if (!JFolder::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'galleries'.DS.$item->id))
                    {
                        $item->gallery = null;
                    }
                }
                $params->set('galleries_rootfolder', 'media/k2/galleries');
                $item->text = $item->gallery;
                if (K2_JVERSION == '15')
                {
                    $dispatcher->trigger('onPrepareContent', array(&$item, &$params, $limitstart));
                }
                else
                {
                    $dispatcher->trigger('onContentPrepare', array('com_k2.'.$view, &$item, &$params, $limitstart));
                }
                $item->gallery = $item->text;
            }
        }

        //Video
        if (($view == 'item' && $item->params->get('itemVideo')) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemVideo')) || ($view == 'latest' && $item->params->get('latestItemVideo')) || ($view == 'relatedByTag'))
        {
            if (!empty($item->video) && JString::substr($item->video, 0, 1) !== '{')
            {
                $item->video = $item->video;
                $item->videoType = 'embedded';
            }
            else
            {
                $item->videoType = 'allvideos';
                $params->set('afolder', 'media/k2/audio');
                $params->set('vfolder', 'media/k2/videos');

                if (JString::strpos($item->video, 'remote}'))
                {
                    preg_match("#}(.*?){/#s", $item->video, $matches);
                    if (JString::substr($matches[1], 0, 7) != 'http://')
                        $item->video = str_replace($matches[1], JURI::root().$matches[1], $item->video);
                }

                if ($view == 'item')
                {
                    $params->set('vwidth', $item->params->get('itemVideoWidth'));
                    $params->set('vheight', $item->params->get('itemVideoHeight'));
                    $params->set('autoplay', $item->params->get('itemVideoAutoPlay'));
                }
                else if ($view == 'latest')
                {
                    $params->set('vwidth', $item->params->get('latestItemVideoWidth'));
                    $params->set('vheight', $item->params->get('latestItemVideoHeight'));
                    $params->set('autoplay', $item->params->get('latestItemVideoAutoPlay'));
                }
                else
                {
                    $params->set('vwidth', $item->params->get('catItemVideoWidth'));
                    $params->set('vheight', $item->params->get('catItemVideoHeight'));
                    $params->set('autoplay', $item->params->get('catItemVideoAutoPlay'));
                }

                $item->text = $item->video;
                if (K2_JVERSION == '15')
                {
                    $dispatcher->trigger('onPrepareContent', array(&$item, &$params, $limitstart));
                }
                else
                {
                    $dispatcher->trigger('onContentPrepare', array('com_k2.'.$view, &$item, &$params, $limitstart));
                }
                $item->video = $item->text;
            }

        }

        //Plugins
        $item->text = '';
        $params->set('vfolder', NULL);
        $params->set('afolder', NULL);
        $params->set('vwidth', NULL);
        $params->set('vheight', NULL);
        $params->set('autoplay', NULL);
        $params->set('galleries_rootfolder', NULL);
        $params->set('enabledownload', NULL);

        if ($view == 'item')
        {

            if ($item->params->get('itemIntroText'))
                $item->text .= $item->introtext;
            if ($item->params->get('itemFullText'))
                $item->text .= '{K2Splitter}'.$item->fulltext;
        }
        else
        {

            switch($task)
            {
                case '' :
                case 'category' :
                    if ($item->params->get('catItemIntroText'))
                        $item->text .= $item->introtext;
                    break;

                case 'user' :
                    if ($item->params->get('userItemIntroText'))
                        $item->text .= $item->introtext;
                    break;

                case 'tag' :
                    if ($item->params->get('tagItemIntroText'))
                        $item->text .= $item->introtext;
                    break;

                default :
                    if ($item->params->get('genericItemIntroText'))
                        $item->text .= $item->introtext;
                    break;
            }

        }
        $item->event = new stdClass;
        if (K2_JVERSION != '15')
        {

            $item->event->BeforeDisplay = '';
            $item->event->AfterDisplay = '';

            $dispatcher->trigger('onContentPrepare', array('com_k2.'.$view, &$item, &$params, $limitstart));

            $results = $dispatcher->trigger('onContentAfterTitle', array('com_k2.'.$view, &$item, &$params, $limitstart));
            $item->event->AfterDisplayTitle = trim(implode("\n", $results));

            $results = $dispatcher->trigger('onContentBeforeDisplay', array('com_k2.'.$view, &$item, &$params, $limitstart));
            $item->event->BeforeDisplayContent = trim(implode("\n", $results));

            $results = $dispatcher->trigger('onContentAfterDisplay', array('com_k2.'.$view, &$item, &$params, $limitstart));
            $item->event->AfterDisplayContent = trim(implode("\n", $results));

        }
        else
        {
            $results = $dispatcher->trigger('onBeforeDisplay', array(&$item, &$params, $limitstart));
            $item->event->BeforeDisplay = trim(implode("\n", $results));

            $results = $dispatcher->trigger('onAfterDisplay', array(&$item, &$params, $limitstart));
            $item->event->AfterDisplay = trim(implode("\n", $results));

            $results = $dispatcher->trigger('onAfterDisplayTitle', array(&$item, &$params, $limitstart));
            $item->event->AfterDisplayTitle = trim(implode("\n", $results));

            $results = $dispatcher->trigger('onBeforeDisplayContent', array(&$item, &$params, $limitstart));
            $item->event->BeforeDisplayContent = trim(implode("\n", $results));

            $results = $dispatcher->trigger('onAfterDisplayContent', array(&$item, &$params, $limitstart));
            $item->event->AfterDisplayContent = trim(implode("\n", $results));

            $dispatcher->trigger('onPrepareContent', array(&$item, &$params, $limitstart));

        }

        //K2 plugins
        $item->event->K2BeforeDisplay = '';
        $item->event->K2AfterDisplay = '';
        $item->event->K2AfterDisplayTitle = '';
        $item->event->K2BeforeDisplayContent = '';
        $item->event->K2AfterDisplayContent = '';

        if (($view == 'item' && $item->params->get('itemK2Plugins')) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemK2Plugins')) || ($view == 'itemlist' && $task == 'user' && $item->params->get('userItemK2Plugins')))
        {
            JPluginHelper::importPlugin('k2');

            $results = $dispatcher->trigger('onK2BeforeDisplay', array(&$item, &$params, $limitstart));
            $item->event->K2BeforeDisplay = trim(implode("\n", $results));

            $results = $dispatcher->trigger('onK2AfterDisplay', array(&$item, &$params, $limitstart));
            $item->event->K2AfterDisplay = trim(implode("\n", $results));

            $results = $dispatcher->trigger('onK2AfterDisplayTitle', array(&$item, &$params, $limitstart));
            $item->event->K2AfterDisplayTitle = trim(implode("\n", $results));

            $results = $dispatcher->trigger('onK2BeforeDisplayContent', array(&$item, &$params, $limitstart));
            $item->event->K2BeforeDisplayContent = trim(implode("\n", $results));

            $results = $dispatcher->trigger('onK2AfterDisplayContent', array(&$item, &$params, $limitstart));
            $item->event->K2AfterDisplayContent = trim(implode("\n", $results));

            $dispatcher->trigger('onK2PrepareContent', array(&$item, &$params, $limitstart));

        }

        if ($view == 'item')
        {
            @list($item->introtext, $item->fulltext) = explode('{K2Splitter}', $item->text);
        }
        else
        {
            $item->introtext = $item->text;
        }

        // Extra fields plugins
        if (($view == 'item' && $item->params->get('itemExtraFields')) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemExtraFields')))
        {
            if (count($item->extra_fields) && is_array($item->extra_fields))
            {
                foreach ($item->extra_fields as $key => $extraField)
                {
                    if ($extraField->type == 'textarea' || $extraField->type == 'textfield')
                    {
                        $tmp = new JObject();
                        $tmp->text = $extraField->value;
                        if (K2_JVERSION != '15')
                        {
                            $dispatcher->trigger('onContentPrepare', array('com_k2.'.$view, &$tmp, &$params, $limitstart));
                        }
                        else
                        {
                            $dispatcher->trigger('onPrepareContent', array(&$tmp, &$params, $limitstart));
                        }
                        $dispatcher->trigger('onK2PrepareContent', array(&$tmp, &$params, $limitstart));
                        $extraField->value = $tmp->text;
                    }
                }
            }
        }
        return $item;

    }

    function hit($id)
    {

        $row = JTable::getInstance('K2Item', 'Table');
        $row->hit($id);
    }

    function vote()
    {

        $mainframe = JFactory::getApplication();
        JTable::addIncludePath(JPATH_COMPONENT_ADMINISTRATOR.DS.'tables');

        //Get item
        $item = JTable::getInstance('K2Item', 'Table');
        $item->load(JRequest::getInt('itemID'));

        //Get category
        $category = JTable::getInstance('K2Category', 'Table');
        $category->load($item->catid);

        //Access check
        $user = JFactory::getUser();
        if (K2_JVERSION != '15')
        {
            if (!in_array($item->access, $user->getAuthorisedViewLevels()) || !in_array($category->access, $user->getAuthorisedViewLevels()))
            {
                JError::raiseError(403, JText::_('K2_ALERTNOTAUTH'));
            }
        }
        else
        {
            if ($item->access > $user->get('aid', 0) || $category->access > $user->get('aid', 0))
            {
                JError::raiseError(403, JText::_('K2_ALERTNOTAUTH'));
            }
        }

        //Published check
        if (!$item->published || $item->trash)
        {
            JError::raiseError(404, JText::_('K2_ITEM_NOT_FOUND'));
        }
        if (!$category->published || $category->trash)
        {
            JError::raiseError(404, JText::_('K2_ITEM_NOT_FOUND'));
        }

        $rate = JRequest::getVar('user_rating', 0, '', 'int');

        if ($rate >= 1 && $rate <= 5)
        {
            $db = JFactory::getDBO();
            $userIP = $_SERVER['REMOTE_ADDR'];
            $query = "SELECT * FROM #__k2_rating WHERE itemID =".(int)$item->id;
            $db->setQuery($query);
            $rating = $db->loadObject();

            if (!$rating)
            {
                $query = "INSERT INTO #__k2_rating ( itemID, lastip, rating_sum, rating_count ) VALUES ( ".(int)$item->id.", ".$db->Quote($userIP).", {$rate}, 1 )";
                $db->setQuery($query);
                $db->query();
                echo JText::_('K2_THANKS_FOR_RATING');

            }

            else
            {
                if ($userIP != ($rating->lastip))
                {
                    $query = "UPDATE #__k2_rating"." SET rating_count = rating_count + 1, rating_sum = rating_sum + {$rate}, lastip = ".$db->Quote($userIP)." WHERE itemID = {$item->id}";
                    $db->setQuery($query);
                    $db->query();
                    echo JText::_('K2_THANKS_FOR_RATING');

                }
                else
                {
                    echo JText::_('K2_YOU_HAVE_ALREADY_RATED_THIS_ITEM');
                }
            }

        }
        $mainframe->close();
    }

    function getRating($id)
    {
        $id = (int)$id;
        static $K2RatingsInstances = array();
        if (array_key_exists($id, $K2RatingsInstances))
        {
            return $K2RatingsInstances[$id];
        }
        $db = JFactory::getDBO();
        $query = "SELECT * FROM #__k2_rating WHERE itemID = ".$id;
        $db->setQuery($query);
        $vote = $db->loadObject();
        $K2RatingsInstances[$id] = $vote;
        return $K2RatingsInstances[$id];
    }

    function getVotesNum($itemID = NULL)
    {

        $mainframe = JFactory::getApplication();
        $user = JFactory::getUser();
        $xhr = false;
        if (is_null($itemID))
        {
            $itemID = JRequest::getInt('itemID');
            $xhr = true;
        }

        $vote = $this->getRating($itemID);

        if (!is_null($vote))
            $rating_count = intval($vote->rating_count);
        else
            $rating_count = 0;

        if ($rating_count != 1)
        {
            $result = "(".$rating_count." ".JText::_('K2_VOTES').")";
        }
        else
        {
            $result = "(".$rating_count." ".JText::_('K2_VOTE').")";
        }
        if ($xhr)
        {
            echo $result;
            $mainframe->close();
        }
        else
            return $result;
    }

    function getVotesPercentage($itemID = NULL)
    {

        $mainframe = JFactory::getApplication();
        $user = JFactory::getUser();
        $db = JFactory::getDBO();
        $xhr = false;
        $result = 0;
        if (is_null($itemID))
        {

            $itemID = JRequest::getInt('itemID');
            $xhr = true;
        }

        $vote = $this->getRating($itemID);

        if (!is_null($vote) && $vote->rating_count != 0)
        {
            $result = number_format(intval($vote->rating_sum) / intval($vote->rating_count), 2) * 20;
        }
        if ($xhr)
        {
            echo $result;
            $mainframe->close();
        }
        else
            return $result;
    }

    function comment()
    {

        $mainframe = JFactory::getApplication();
        jimport('joomla.mail.helper');
        JTable::addIncludePath(JPATH_COMPONENT_ADMINISTRATOR.DS.'tables');
        $params = K2HelperUtilities::getParams('com_k2');
        $user = JFactory::getUser();
        $config = JFactory::getConfig();

        JLoader::register('Services_JSON', JPATH_ADMINISTRATOR.DS.'components'.DS.'com_k2'.DS.'lib'.DS.'JSON.php');
        $json = new Services_JSON;
        $response = new JObject();

        //Get item
        $item = JTable::getInstance('K2Item', 'Table');
        $item->load(JRequest::getInt('itemID'));

        //Get category
        $category = JTable::getInstance('K2Category', 'Table');
        $category->load($item->catid);

        //Access check
        if (K2_JVERSION != '15')
        {
            if (!in_array($item->access, $user->getAuthorisedViewLevels()) || !in_array($category->access, $user->getAuthorisedViewLevels()))
            {
                JError::raiseError(403, JText::_('K2_ALERTNOTAUTH'));
            }
        }
        else
        {
            if ($item->access > $user->get('aid', 0) || $category->access > $user->get('aid', 0))
            {
                JError::raiseError(403, JText::_('K2_ALERTNOTAUTH'));
            }
        }

        //Published check
        if (!$item->published || $item->trash)
        {
            JError::raiseError(404, JText::_('K2_ITEM_NOT_FOUND'));
        }
        if (!$category->published || $category->trash)
        {
            JError::raiseError(404, JText::_('K2_ITEM_NOT_FOUND'));
        }

        //Check permissions
        if ((($params->get('comments') == '2') && ($user->id > 0) && K2HelperPermissions::canAddComment($item->catid)) || ($params->get('comments') == '1'))
        {

            $row = JTable::getInstance('K2Comment', 'Table');

            if (!$row->bind(JRequest::get('post')))
            {
                $response->message($row->getError());
                echo $json->encode($response);
                $mainframe->close();
            }

            $row->commentText = JRequest::getString('commentText', '', 'default');
            $row->commentText = strip_tags($row->commentText);
            //Strip a tags since all urls will be converted to links automatically on runtime.
            //Additionaly strip tables to avoid layout issues.
            //Also strip all attributes except src, alt and title.
            //$filter	= new JFilterInput(array('a', 'table'), array('src', 'alt', 'title'), 1);
            //$row->commentText = $filter->clean( $row->commentText );

            //Clean vars
            $filter = JFilterInput::getInstance();
            $row->userName = $filter->clean($row->userName, 'username');
            if ($row->commentURL && preg_match('/^((http|https|ftp):\/\/)?[a-z0-9]+([\-\.]{1}[a-z0-9]+)*\.[a-z]{2,6}((:[0-9]{1,5})?\/.*)?$/i', $row->commentURL))
            {
                $url = preg_replace('|[^a-z0-9-~+_.?#=&;,/:]|i', '', $row->commentURL);
                $url = str_replace(';//', '://', $url);
                if ($url != '')
                {
                    $url = (!strstr($url, '://')) ? 'http://'.$url : $url;
                    $url = preg_replace('/&([^#])(?![a-z]{2,8};)/', '&#038;$1', $url);
                    $row->commentURL = $url;
                }
            }
            else
            {
                $row->commentURL = '';
            }

            $datenow = JFactory::getDate();
            $row->commentDate = K2_JVERSION == '15' ? $datenow->toMySQL() : $datenow->toSql();

            if (!$user->guest)
            {
                $row->userID = $user->id;
                $row->commentEmail = $user->email;
                $row->userName = $user->name;
            }

            $userName = trim($row->userName);
            $commentEmail = trim($row->commentEmail);
            $commentText = trim($row->commentText);
            $commentURL = trim($row->commentURL);

            if (empty($userName) || $userName == JText::_('K2_ENTER_YOUR_NAME') || empty($commentText) || $commentText == JText::_('K2_ENTER_YOUR_MESSAGE_HERE') || empty($commentEmail) || $commentEmail == JText::_('K2_ENTER_YOUR_EMAIL_ADDRESS'))
            {
                $response->message = JText::_('K2_YOU_NEED_TO_FILL_IN_ALL_REQUIRED_FIELDS');
                echo $json->encode($response);
                $mainframe->close();
            }

            if (!JMailHelper::isEmailAddress($commentEmail))
            {
                $response->message = JText::_('K2_INVALID_EMAIL_ADDRESS');
                echo $json->encode($response);
                $mainframe->close();
            }

            if ($user->guest)
            {
                $db = JFactory::getDBO();
                $query = "SELECT COUNT(*) FROM #__users WHERE name=".$db->Quote($userName)." OR email=".$db->Quote($commentEmail);
                $db->setQuery($query);
                $result = $db->loadresult();
                if ($result > 0)
                {
                    $response->message = JText::_('K2_THE_NAME_OR_EMAIL_ADDRESS_YOU_TYPED_IS_ALREADY_IN_USE');
                    echo $json->encode($response);
                    $mainframe->close();
                }

            }

            if ($params->get('recaptcha') && $user->guest)
            {
                if (!function_exists('_recaptcha_qsencode'))
                {
                    require_once (JPATH_ADMINISTRATOR.DS.'components'.DS.'com_k2'.DS.'lib'.DS.'recaptchalib.php');
                }
                $privatekey = $params->get('recaptcha_private_key');
                $recaptcha_challenge_field = isset($_POST["recaptcha_challenge_field"]) ? $_POST["recaptcha_challenge_field"] : '';
                $recaptcha_response_field = isset($_POST["recaptcha_response_field"]) ? $_POST["recaptcha_response_field"] : '';
                $resp = recaptcha_check_answer($privatekey, $_SERVER["REMOTE_ADDR"], $recaptcha_challenge_field, $recaptcha_response_field);
                if (!$resp->is_valid)
                {
                    $response->message = JText::_('K2_THE_WORDS_YOU_TYPED_DID_NOT_MATCH_THE_ONES_DISPLAYED_PLEASE_TRY_AGAIN');
                    echo $json->encode($response);
                    $mainframe->close();
                }
            }

            if ($commentURL == JText::_('K2_ENTER_YOUR_SITE_URL') || $commentURL == "")
            {
                $row->commentURL = NULL;
            }
            else
            {
                if (substr($commentURL, 0, 7) != 'http://')
                {
                    $row->commentURL = 'http://'.$commentURL;
                }
            }

            if ($params->get('commentsPublishing'))
            {
                $row->published = 1;
            }
            else
            {
                $row->published = 0;
                // Auto publish comments for users with administrative permissions
                if (K2_JVERSION != '15')
                {
                    if ($user->authorise('core.admin'))
                    {
                        $row->published = 1;
                    }
                }
                else
                {
                    if ($user->gid > 23)
                    {
                        $row->published = 1;
                    }
                }
            }

            if (!$row->store())
            {
                $response->message = $row->getError();
                echo $json->encode($response);
                $mainframe->close();
            }

            if ($row->published)
            {
                $caching = K2_JVERSION == '30' ? $config->get('caching') : $config->getValue('config.caching');
                if ($caching && $user->guest)
                {
                    $response->message = JText::_('K2_THANK_YOU_YOUR_COMMENT_WILL_BE_PUBLISHED_SHORTLY');
                    echo $json->encode($response);
                }
                else
                {
                    $response->message = JText::_('K2_COMMENT_ADDED_REFRESHING_PAGE');
                    $response->refresh = 1;
                    echo $json->encode($response);
                }

            }
            else
            {
                $response->message = JText::_('K2_COMMENT_ADDED_AND_WAITING_FOR_APPROVAL');
                echo $json->encode($response);
            }

        }
        $mainframe->close();
    }

    function getItemTags($itemID)
    {
        $itemID = (int)$itemID;
        static $K2ItemTagsInstances = array();
        if (isset($K2ItemTagsInstances[$itemID]))
        {
            return $K2ItemTagsInstances[$itemID];
        }
        $db = JFactory::getDBO();

        $query = "SELECT tag.*
		FROM #__k2_tags AS tag 
		JOIN #__k2_tags_xref AS xref ON tag.id = xref.tagID 
		WHERE tag.published=1 
		AND xref.itemID = ".(int)$itemID." ORDER BY xref.id ASC";

        $db->setQuery($query);
        $rows = $db->loadObjectList();
        $K2ItemTagsInstances[$itemID] = $rows;
        return $K2ItemTagsInstances[$itemID];
    }

    function getItemExtraFields($itemExtraFields)
    {

        static $K2ItemExtraFieldsInstances = array();
        if (isset($K2ItemExtraFieldsInstances[$itemExtraFields]))
        {
            return $K2ItemExtraFieldsInstances[$itemExtraFields];
        }

        jimport('joomla.filesystem.file');
        $db = JFactory::getDBO();
        require_once (JPATH_ADMINISTRATOR.DS.'components'.DS.'com_k2'.DS.'lib'.DS.'JSON.php');
        $json = new Services_JSON;
        $jsonObjects = $json->decode($itemExtraFields);
        $imgExtensions = array('jpg', 'jpeg', 'gif', 'png');
        $params = K2HelperUtilities::getParams('com_k2');

        if (count($jsonObjects) < 1)
        {
            return NULL;
        }

        foreach ($jsonObjects as $object)
        {
            $extraFieldsIDs[] = $object->id;
        }
        JArrayHelper::toInteger($extraFieldsIDs);
        $condition = @implode(',', $extraFieldsIDs);

        $query = "SELECT * FROM #__k2_extra_fields WHERE published=1 AND id IN ({$condition}) ORDER BY ordering ASC";
        $db->setQuery($query);
        $rows = $db->loadObjectList();
        $size = count($rows);
        for ($i = 0; $i < $size; $i++)
        {

            $value = '';
            $values = array();
            foreach ($jsonObjects as $object)
            {

                if ($rows[$i]->id == $object->id)
                {

                    if ($rows[$i]->type == 'textfield' || $rows[$i]->type == 'textarea' || $rows[$i]->type == 'date')
                    {
                        $value = $object->value;
                        if ($rows[$i]->type == 'date' && $value)
                        {
                            $offset = (K2_JVERSION != '15') ? null : 0;
                            $value = JHTML::_('date', $value, JText::_('K2_DATE_FORMAT_LC'), $offset);
                        }

                    }
                    else if ($rows[$i]->type == 'labels')
                    {
                        $labels = explode(',', $object->value);
                        if (!is_array($labels))
                        {
                            $labels = (array)$labels;
                        }
                        $value = '';
                        foreach ($labels as $label)
                        {
                            $label = JString::trim($label);
                            $label = str_replace('-', ' ', $label);
                            $value .= '<a href="'.JRoute::_('index.php?option=com_k2&view=itemlist&task=search&searchword='.urlencode($label)).'">'.$label.'</a> ';
                        }

                    }
                    else if ($rows[$i]->type == 'select' || $rows[$i]->type == 'radio')
                    {
                        foreach ($json->decode($rows[$i]->value) as $option)
                        {
                            if ($option->value == $object->value)
                            {
                                $value .= $option->name;
                            }

                        }
                    }
                    else if ($rows[$i]->type == 'multipleSelect')
                    {
                        foreach ($json->decode($rows[$i]->value) as $option)
                        {
                            if (@in_array($option->value, $object->value))
                            {
                                $values[] = $option->name;
                            }

                        }
                        $value = @implode(', ', $values);
                    }
                    else if ($rows[$i]->type == 'csv')
                    {
                        $array = $object->value;
                        if (count($array))
                        {
                            $value .= '<table cellspacing="0" cellpadding="0" class="csvTable">';
                            foreach ($array as $key => $row)
                            {
                                $value .= '<tr>';
                                foreach ($row as $cell)
                                {
                                    $value .= ($key > 0) ? '<td>'.$cell.'</td>' : '<th>'.$cell.'</th>';
                                }
                                $value .= '</tr>';
                            }
                            $value .= '</table>';
                        }

                    }

                    else
                    {

                        switch ($object->value[2])
                        {
                            case 'same' :
                            default :
                                $attributes = '';
                                break;

                            case 'new' :
                                $attributes = 'target="_blank"';
                                break;

                            case 'popup' :
                                $attributes = 'class="classicPopup" rel="{\'x\':'.$params->get('linkPopupWidth').',\'y\':'.$params->get('linkPopupHeight').'}"';
                                break;

                            case 'lightbox' :
                                $filename = @basename($object->value[1]);
                                $extension = JFile::getExt($filename);
                                if (!empty($extension) && in_array($extension, $imgExtensions))
                                {
                                    $attributes = 'class="modal"';
                                }
                                else
                                {
                                    $attributes = 'class="modal" rel="{handler:\'iframe\',size:{x:'.$params->get('linkPopupWidth').',y:'.$params->get('linkPopupHeight').'}}"';
                                }
                                break;
                        }
                        $object->value[0] = JString::trim($object->value[0]);
                        $object->value[1] = JString::trim($object->value[1]);

                        if ($object->value[1] && ($object->value[1] != 'http://' || $object->value[1] != 'https://'))
                        {
                            if ($object->value[0] == '')
                            {
                                $object->value[0] = $object->value[1];
                            }
                            $value = '<a href="'.$object->value[1].'" '.$attributes.'>'.$object->value[0].'</a>';
                        }
                        else
                        {
                            $value = false;
                        }
                    }

                }

            }
            if ($value)
            {
                $rows[$i]->value = $value;
            }
            else
            {
                unset($rows[$i]);
            }
        }
        $K2ItemExtraFieldsInstances[$itemExtraFields] = $rows;
        return $K2ItemExtraFieldsInstances[$itemExtraFields];
    }

    function getItemAttachments($itemID)
    {
        $itemID = (int)$itemID;
        static $K2ItemAttachmentsInstances = array();
        if (isset($K2ItemAttachmentsInstances[$itemID]))
        {
            return $K2ItemAttachmentsInstances[$itemID];
        }

        $db = JFactory::getDBO();
        $query = "SELECT * FROM #__k2_attachments WHERE itemID=".$itemID;
        $db->setQuery($query);
        $rows = $db->loadObjectList();
        foreach ($rows as $row)
        {
            $row->link = JRoute::_('index.php?option=com_k2&view=item&task=download&id='.$row->id.'_'.JUtility::getHash($row->id));
        }
        $K2ItemAttachmentsInstances[$itemID] = $rows;
        return $K2ItemAttachmentsInstances[$itemID];
    }

    function getItemComments($itemID, $limitstart, $limit, $published = true)
    {

        $params = K2HelperUtilities::getParams('com_k2');
        $order = $params->get('commentsOrdering', 'DESC');
        $ordering = ($order == 'DESC') ? 'DESC' : 'ASC';
        $db = JFactory::getDBO();
        $query = "SELECT * FROM #__k2_comments WHERE itemID=".(int)$itemID;
        if ($published)
        {
            $query .= " AND published=1 ";
        }
        $query .= " ORDER BY commentDate {$ordering}";
        $db->setQuery($query, $limitstart, $limit);
        $rows = $db->loadObjectList();
        return $rows;
    }

    function countItemComments($itemID, $published = true)
    {

        $itemID = (int)$itemID;
        $index = $itemID.'_'.(int)$published;
        static $K2ItemCommentsCountInstances = array();
        if (isset($K2ItemCommentsCountInstances[$index]))
        {
            return $K2ItemCommentsCountInstances[$index];
        }

        $db = JFactory::getDBO();
        $query = "SELECT COUNT(*) FROM #__k2_comments WHERE itemID=".$itemID;
        if ($published)
        {
            $query .= " AND published=1 ";
        }
        $db->setQuery($query);
        $result = $db->loadResult();
        $K2ItemCommentsCountInstances[$index] = $result;
        return $K2ItemCommentsCountInstances[$index];

    }

    function checkin()
    {

        $mainframe = JFactory::getApplication();
        $id = JRequest::getInt('cid');
        $row = JTable::getInstance('K2Item', 'Table');
        $row->load($id);
        $row->checkin();
        $mainframe->close();
    }

    function getPreviousItem($id, $catid, $ordering)
    {

        $mainframe = JFactory::getApplication();
        $user = JFactory::getUser();
        $id = (int)$id;
        $catid = (int)$catid;
        $ordering = (int)$ordering;
        $db = JFactory::getDBO();

        $jnow = JFactory::getDate();
        $now = K2_JVERSION == '15' ? $jnow->toMySQL() : $jnow->toSql();
        $nullDate = $db->getNullDate();

        if (K2_JVERSION != '15')
        {
            $accessCondition = ' AND access IN('.implode(',', $user->getAuthorisedViewLevels()).')';
        }
        else
        {
            $accessCondition = ' AND access <= '.$user->aid;
            ;
        }

        $languageCondition = '';
        if (K2_JVERSION != '15')
        {
            if ($mainframe->getLanguageFilter())
            {
                $languageCondition = "AND language IN (".$db->quote(JFactory::getLanguage()->getTag()).",".$db->quote('*').")";
            }
        }

        if ($ordering == "0")
        {
            $query = "SELECT * FROM #__k2_items WHERE id < {$id} AND catid={$catid} AND published=1 AND ( publish_up = ".$db->Quote($nullDate)." OR publish_up <= ".$db->Quote($now)." ) AND ( publish_down = ".$db->Quote($nullDate)." OR publish_down >= ".$db->Quote($now)." ) {$accessCondition} AND trash=0 {$languageCondition} ORDER BY ordering DESC";
        }
        else
        {
            $query = "SELECT * FROM #__k2_items WHERE id != {$id} AND catid={$catid} AND ordering < {$ordering} AND published=1 AND ( publish_up = ".$db->Quote($nullDate)." OR publish_up <= ".$db->Quote($now)." ) AND ( publish_down = ".$db->Quote($nullDate)." OR publish_down >= ".$db->Quote($now)." ) {$accessCondition} AND trash=0 {$languageCondition} ORDER BY ordering DESC";
        }

        $db->setQuery($query, 0, 1);
        $row = $db->loadObject();
        return $row;
    }

    function getNextItem($id, $catid, $ordering)
    {

        $mainframe = JFactory::getApplication();
        $user = JFactory::getUser();
        $id = (int)$id;
        $catid = (int)$catid;
        $ordering = (int)$ordering;
        $db = JFactory::getDBO();

        $jnow = JFactory::getDate();
        $now = K2_JVERSION == '15' ? $jnow->toMySQL() : $jnow->toSql();
        $nullDate = $db->getNullDate();

        if (K2_JVERSION != '15')
        {
            $accessCondition = ' AND access IN('.implode(',', $user->getAuthorisedViewLevels()).')';
        }
        else
        {
            $accessCondition = ' AND access <= '.$user->aid;
            ;
        }

        $languageCondition = '';
        if (K2_JVERSION != '15')
        {
            if ($mainframe->getLanguageFilter())
            {
                $languageCondition = "AND language IN (".$db->quote(JFactory::getLanguage()->getTag()).",".$db->quote('*').")";
            }
        }

        if ($ordering == "0")
        {
            $query = "SELECT * FROM #__k2_items WHERE id > {$id} AND catid={$catid} AND published=1 AND ( publish_up = ".$db->Quote($nullDate)." OR publish_up <= ".$db->Quote($now)." ) AND ( publish_down = ".$db->Quote($nullDate)." OR publish_down >= ".$db->Quote($now)." ) {$accessCondition} AND trash=0 {$languageCondition} ORDER BY ordering ASC";
        }
        else
        {
            $query = "SELECT * FROM #__k2_items WHERE id != {$id} AND catid={$catid} AND ordering > {$ordering} AND published=1 AND ( publish_up = ".$db->Quote($nullDate)." OR publish_up <= ".$db->Quote($now)." ) AND ( publish_down = ".$db->Quote($nullDate)." OR publish_down >= ".$db->Quote($now)." ) {$accessCondition} AND trash=0 {$languageCondition} ORDER BY ordering ASC";
        }
        $db->setQuery($query, 0, 1);
        $row = $db->loadObject();
        return $row;
    }

    function getUserProfile($id = NULL)
    {

        $db = JFactory::getDBO();
        if (is_null($id))
            $id = JRequest::getInt('id');

        static $K2UsersInstances = array();
        if (isset($K2UsersInstances[$id]))
        {
            return $K2UsersInstances[$id];
        }

        $query = "SELECT id, gender, description, image, url, `group`, plugins FROM #__k2_users WHERE userID={$id}";
        $db->setQuery($query);
        $row = $db->loadObject();
        $K2UsersInstances[$id] = $row;
        return $row;
    }

}
